package com.ruoyi.manager.mapper;

import java.util.List;
import java.util.Map;

public interface TeacherAnalysisMapper {

    //查询班级信息一览
    List<Map<String,Object>> listClassesInfor();

    List<Map<String,Object>> listClassesInfor2();

    List<Map<String,Object>> listClassesInfor3();

    Map<String, Object> getscore_sum();

    Map<String, Object> getscore_avg();


    //查询学生等级人数
    public Map<String,Integer> listStudentLevelCount();

    //查询所有在训班级的平均成绩
    public List<Map<String,Object>> listClassesAvgScore();

    public List<Map<String,Object>> listCS();

    //当周核心作业完成率
    Map<String, Object> getcoreExCompleteRate();

    //当周核心作业提交率
    Map<String, Object> getcoreExCommitRate();

    //40%以下占比
    Map<String, Object> getcoreExLt40Rate();

    //80%以上占比
    Map<String, Object> getcoreExGt80Rate();

    //查询当周各班级考核次数
    public List<Map<String,Object>> listExamNumber();

    public List<Map<String,Object>> exerciseSum();

    public List<Map<String,Object>> citySum();
}
